﻿CREATE TABLE [steve].[SiteUrlRevision] (
    [SiteUrlId]            UNIQUEIDENTIFIER NOT NULL,
    [RevisionNumber]       INT              NOT NULL,
    [StartDate]            DATETIME2(7)         NULL,
    [EndDate]              DATETIME2(7)         NULL,
    [IsSecure]             BIT              NOT NULL,
	[IgnoreQueryString]    BIT              NOT NULL,
    [PageTitle]            NVARCHAR (200)   NULL,
    [PageMetaDescription]  NVARCHAR (200)   NULL,
    [PageMetaKeywords]     NVARCHAR (200)   NULL,
    [RevisionComment]      nVARCHAR (400)    NOT NULL,
    [RevisionDate]         DATETIME2(7)         NOT NULL,
    [RevisionMembershipId] UNIQUEIDENTIFIER NULL
);

